Overview

Dataset statistics

Number of variables25
Number of observations29459
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.6 MiB
Average record size in memory200.0 B

Variable types

NUM21
CAT3
BOOL1

Reproduction

Analysis started2020-07-28 08:28:16.033969
Analysis finished2020-07-28 08:29:41.772545
Duration1 minute and 25.74 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

bill_amt2 is highly correlated with bill_amt1 and 2 other fieldsHigh correlation
bill_amt1 is highly correlated with bill_amt2 and 1 other fieldsHigh correlation
bill_amt3 is highly correlated with bill_amt1 and 3 other fieldsHigh correlation
bill_amt4 is highly correlated with bill_amt2 and 3 other fieldsHigh correlation
bill_amt5 is highly correlated with bill_amt3 and 2 other fieldsHigh correlation
bill_amt6 is highly correlated with bill_amt4 and 1 other fieldsHigh correlation
df_index has unique values Unique
pay_0 has 14445 (49.0%) zeros Zeros
pay_2 has 15422 (52.4%) zeros Zeros
pay_3 has 15463 (52.5%) zeros Zeros
pay_4 has 16138 (54.8%) zeros Zeros
pay_5 has 16596 (56.3%) zeros Zeros
pay_6 has 15949 (54.1%) zeros Zeros
bill_amt1 has 1986 (6.7%) zeros Zeros
bill_amt2 has 2472 (8.4%) zeros Zeros
bill_amt3 has 2835 (9.6%) zeros Zeros
bill_amt4 has 3160 (10.7%) zeros Zeros
bill_amt5 has 3470 (11.8%) zeros Zeros
bill_amt6 has 3969 (13.5%) zeros Zeros
pay_amt1 has 5169 (17.5%) zeros Zeros
pay_amt2 has 5309 (18.0%) zeros Zeros
pay_amt3 has 5884 (20.0%) zeros Zeros
pay_amt4 has 6324 (21.5%) zeros Zeros
pay_amt5 has 6603 (22.4%) zeros Zeros
pay_amt6 has 7065 (24.0%) zeros Zeros

Variables

df_index
Real number (ℝ≥0)

UNIQUE

Distinct count29459
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15002.93255032418
Minimum0
Maximum29999
Zeros1
Zeros (%)< 0.1%
Memory size230.3 KiB

Quantile statistics

Minimum0
5-th percentile1506.9
Q17513.5
median15013
Q322493.5
95-th percentile28493.1
Maximum29999
Range29999
Interquartile range (IQR)14980

Descriptive statistics

Standard deviation8657.215564
Coefficient of variation (CV)0.577034892
Kurtosis-1.199756933
Mean15002.93255
Median Absolute Deviation (MAD)7491
Skewness-0.0004932886091
Sum441971390
Variance74947381.32
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
20471< 0.1%
 
33071< 0.1%
 
155971< 0.1%
 
94541< 0.1%
 
115031< 0.1%
 
217601< 0.1%
 
238091< 0.1%
 
176661< 0.1%
 
197151< 0.1%
 
299561< 0.1%
 
258621< 0.1%
 
279111< 0.1%
 
53841< 0.1%
 
74331< 0.1%
 
12901< 0.1%
 
33391< 0.1%
 
135801< 0.1%
 
156291< 0.1%
 
94861< 0.1%
 
115351< 0.1%
 
217921< 0.1%
 
238411< 0.1%
 
176981< 0.1%
 
197471< 0.1%
 
299881< 0.1%
 
Other values (29434)2943499.9%
 
ValueCountFrequency (%) 
01< 0.1%
 
11< 0.1%
 
21< 0.1%
 
31< 0.1%
 
41< 0.1%
 
51< 0.1%
 
61< 0.1%
 
71< 0.1%
 
81< 0.1%
 
91< 0.1%
 
ValueCountFrequency (%) 
299991< 0.1%
 
299981< 0.1%
 
299971< 0.1%
 
299961< 0.1%
 
299951< 0.1%
 
299941< 0.1%
 
299931< 0.1%
 
299921< 0.1%
 
299911< 0.1%
 
299901< 0.1%
 

limit_bal
Real number (ℝ≥0)

Distinct count79
Unique (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean167079.31973250958
Minimum10000
Maximum800000
Zeros0
Zeros (%)0.0%
Memory size230.3 KiB

Quantile statistics

Minimum10000
5-th percentile20000
Q150000
median140000
Q3240000
95-th percentile430000
Maximum800000
Range790000
Interquartile range (IQR)190000

Descriptive statistics

Standard deviation128780.3336
Coefficient of variation (CV)0.7707736289
Kurtosis0.4806109595
Mean167079.3197
Median Absolute Deviation (MAD)90000
Skewness0.9806362923
Sum4921989680
Variance1.658437432e+10
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
50000328711.2%
 
2000019266.5%
 
3000015785.4%
 
8000015455.2%
 
20000015085.1%
 
15000010963.7%
 
10000010383.5%
 
1800009863.3%
 
3600008682.9%
 
600008072.7%
 
1400007412.5%
 
2300007332.5%
 
2100007252.5%
 
1300007212.4%
 
1200007162.4%
 
700007142.4%
 
5000006922.3%
 
1600006902.3%
 
900006402.2%
 
2400006082.1%
 
1100005792.0%
 
3000005461.9%
 
1700005271.8%
 
2600005141.7%
 
2800004861.6%
 
Other values (54)518817.6%
 
ValueCountFrequency (%) 
100004791.6%
 
160002< 0.1%
 
2000019266.5%
 
3000015785.4%
 
400002270.8%
 
50000328711.2%
 
600008072.7%
 
700007142.4%
 
8000015455.2%
 
900006402.2%
 
ValueCountFrequency (%) 
8000002< 0.1%
 
7800002< 0.1%
 
7600001< 0.1%
 
7500003< 0.1%
 
7400002< 0.1%
 
7200003< 0.1%
 
7100006< 0.1%
 
7000008< 0.1%
 
6900001< 0.1%
 
6800003< 0.1%
 

sex
Categorical

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size230.3 KiB
2
17796
1
11663
ValueCountFrequency (%) 
21779660.4%
 
11166339.6%
 

Length

Max length1
Median length1
Mean length1
Min length1

Overview of Unicode Properties

Unique unicode characters2
Unique unicode categories (?)1
Unique unicode scripts (?)1
Unique unicode blocks (?)1
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

ValueCountFrequency (%) 
21779660.4%
 
11166339.6%
 

Most occurring categories

ValueCountFrequency (%) 
Decimal Number29459100.0%
 

Most frequent Decimal Number characters

ValueCountFrequency (%) 
21779660.4%
 
11166339.6%
 

Most occurring scripts

ValueCountFrequency (%) 
Common29459100.0%
 

Most frequent Common characters

ValueCountFrequency (%) 
21779660.4%
 
11166339.6%
 

Most occurring blocks

ValueCountFrequency (%) 
ASCII29459100.0%
 

Most frequent ASCII characters

ValueCountFrequency (%) 
21779660.4%
 
11166339.6%
 

education
Categorical

Distinct count4
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size230.3 KiB
2
13791
1
10459
3
4752
4
 
457
ValueCountFrequency (%) 
21379146.8%
 
11045935.5%
 
3475216.1%
 
44571.6%
 

Length

Max length1
Median length1
Mean length1
Min length1

Overview of Unicode Properties

Unique unicode characters4
Unique unicode categories (?)1
Unique unicode scripts (?)1
Unique unicode blocks (?)1
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

ValueCountFrequency (%) 
21379146.8%
 
11045935.5%
 
3475216.1%
 
44571.6%
 

Most occurring categories

ValueCountFrequency (%) 
Decimal Number29459100.0%
 

Most frequent Decimal Number characters

ValueCountFrequency (%) 
21379146.8%
 
11045935.5%
 
3475216.1%
 
44571.6%
 

Most occurring scripts

ValueCountFrequency (%) 
Common29459100.0%
 

Most frequent Common characters

ValueCountFrequency (%) 
21379146.8%
 
11045935.5%
 
3475216.1%
 
44571.6%
 

Most occurring blocks

ValueCountFrequency (%) 
ASCII29459100.0%
 

Most frequent ASCII characters

ValueCountFrequency (%) 
21379146.8%
 
11045935.5%
 
3475216.1%
 
44571.6%
 

marriage
Categorical

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size230.3 KiB
2
15878
1
13581
ValueCountFrequency (%) 
21587853.9%
 
11358146.1%
 

Length

Max length1
Median length1
Mean length1
Min length1

Overview of Unicode Properties

Unique unicode characters2
Unique unicode categories (?)1
Unique unicode scripts (?)1
Unique unicode blocks (?)1
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

ValueCountFrequency (%) 
21587853.9%
 
11358146.1%
 

Most occurring categories

ValueCountFrequency (%) 
Decimal Number29459100.0%
 

Most frequent Decimal Number characters

ValueCountFrequency (%) 
21587853.9%
 
11358146.1%
 

Most occurring scripts

ValueCountFrequency (%) 
Common29459100.0%
 

Most frequent Common characters

ValueCountFrequency (%) 
21587853.9%
 
11358146.1%
 

Most occurring blocks

ValueCountFrequency (%) 
ASCII29459100.0%
 

Most frequent ASCII characters

ValueCountFrequency (%) 
21587853.9%
 
11358146.1%
 

age
Real number (ℝ≥0)

Distinct count56
Unique (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35.39030516989715
Minimum21
Maximum79
Zeros0
Zeros (%)0.0%
Memory size230.3 KiB

Quantile statistics

Minimum21
5-th percentile23
Q128
median34
Q341
95-th percentile53
Maximum79
Range58
Interquartile range (IQR)13

Descriptive statistics

Standard deviation9.184883452
Coefficient of variation (CV)0.2595310611
Kurtosis0.07959641048
Mean35.39030517
Median Absolute Deviation (MAD)6
Skewness0.7450257384
Sum1042563
Variance84.36208402
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2915905.4%
 
2714625.0%
 
2813934.7%
 
3013714.7%
 
2612474.2%
 
3112034.1%
 
2511814.0%
 
3411473.9%
 
3211443.9%
 
3311293.8%
 
2411203.8%
 
3610963.7%
 
3510963.7%
 
3710123.4%
 
399363.2%
 
389343.2%
 
239283.2%
 
408482.9%
 
418042.7%
 
427762.6%
 
446812.3%
 
436522.2%
 
455952.0%
 
225541.9%
 
465521.9%
 
Other values (31)400813.6%
 
ValueCountFrequency (%) 
21670.2%
 
225541.9%
 
239283.2%
 
2411203.8%
 
2511814.0%
 
2612474.2%
 
2714625.0%
 
2813934.7%
 
2915905.4%
 
3013714.7%
 
ValueCountFrequency (%) 
791< 0.1%
 
753< 0.1%
 
741< 0.1%
 
734< 0.1%
 
723< 0.1%
 
713< 0.1%
 
7010< 0.1%
 
69150.1%
 
685< 0.1%
 
67160.1%
 

pay_0
Real number (ℝ)

ZEROS

Distinct count11
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-0.01738008757934757
Minimum-2
Maximum8
Zeros14445
Zeros (%)49.0%
Memory size230.3 KiB

Quantile statistics

Minimum-2
5-th percentile-2
Q1-1
median0
Q30
95-th percentile2
Maximum8
Range10
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.124582306
Coefficient of variation (CV)-64.70521512
Kurtosis2.732851872
Mean-0.01738008758
Median Absolute Deviation (MAD)1
Skewness0.7333496664
Sum-512
Variance1.264685362
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
01444549.0%
 
-1559919.0%
 
1362212.3%
 
-227159.2%
 
226268.9%
 
33141.1%
 
4750.3%
 
5240.1%
 
8190.1%
 
611< 0.1%
 
79< 0.1%
 
ValueCountFrequency (%) 
-227159.2%
 
-1559919.0%
 
01444549.0%
 
1362212.3%
 
226268.9%
 
33141.1%
 
4750.3%
 
5240.1%
 
611< 0.1%
 
79< 0.1%
 
ValueCountFrequency (%) 
8190.1%
 
79< 0.1%
 
611< 0.1%
 
5240.1%
 
4750.3%
 
33141.1%
 
226268.9%
 
1362212.3%
 
01444549.0%
 
-1559919.0%
 

pay_2
Real number (ℝ)

ZEROS

Distinct count10
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-0.1342543874537493
Minimum-2
Maximum7
Zeros15422
Zeros (%)52.4%
Memory size230.3 KiB

Quantile statistics

Minimum-2
5-th percentile-2
Q1-1
median0
Q30
95-th percentile2
Maximum7
Range9
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.197458438
Coefficient of variation (CV)-8.919324432
Kurtosis1.508418312
Mean-0.1342543875
Median Absolute Deviation (MAD)0
Skewness0.7814386906
Sum-3955
Variance1.433906711
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
01542252.4%
 
-1594520.2%
 
2387013.1%
 
-2372512.6%
 
33211.1%
 
4950.3%
 
1250.1%
 
5240.1%
 
7200.1%
 
612< 0.1%
 
ValueCountFrequency (%) 
-2372512.6%
 
-1594520.2%
 
01542252.4%
 
1250.1%
 
2387013.1%
 
33211.1%
 
4950.3%
 
5240.1%
 
612< 0.1%
 
7200.1%
 
ValueCountFrequency (%) 
7200.1%
 
612< 0.1%
 
5240.1%
 
4950.3%
 
33211.1%
 
2387013.1%
 
1250.1%
 
01542252.4%
 
-1594520.2%
 
-2372512.6%
 

pay_3
Real number (ℝ)

ZEROS

Distinct count10
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-0.16853932584269662
Minimum-2
Maximum7
Zeros15463
Zeros (%)52.5%
Memory size230.3 KiB

Quantile statistics

Minimum-2
5-th percentile-2
Q1-1
median0
Q30
95-th percentile2
Maximum7
Range9
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.193314857
Coefficient of variation (CV)-7.080334818
Kurtosis1.830949329
Mean-0.1685393258
Median Absolute Deviation (MAD)0
Skewness0.8025290059
Sum-4965
Variance1.424000348
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
01546352.5%
 
-1583119.8%
 
-2402913.7%
 
2375812.8%
 
32340.8%
 
4730.2%
 
7240.1%
 
6230.1%
 
5210.1%
 
13< 0.1%
 
ValueCountFrequency (%) 
-2402913.7%
 
-1583119.8%
 
01546352.5%
 
13< 0.1%
 
2375812.8%
 
32340.8%
 
4730.2%
 
5210.1%
 
6230.1%
 
7240.1%
 
ValueCountFrequency (%) 
7240.1%
 
6230.1%
 
5210.1%
 
4730.2%
 
32340.8%
 
2375812.8%
 
13< 0.1%
 
01546352.5%
 
-1583119.8%
 
-2402913.7%
 

pay_4
Real number (ℝ)

ZEROS

Distinct count10
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-0.2227163175939441
Minimum-2
Maximum7
Zeros16138
Zeros (%)54.8%
Memory size230.3 KiB

Quantile statistics

Minimum-2
5-th percentile-2
Q1-1
median0
Q30
95-th percentile2
Maximum7
Range9
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.165999383
Coefficient of variation (CV)-5.235356777
Kurtosis3.23097029
Mean-0.2227163176
Median Absolute Deviation (MAD)0
Skewness0.9587710912
Sum-6561
Variance1.35955456
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
01613854.8%
 
-1557818.9%
 
-2429214.6%
 
2311410.6%
 
31750.6%
 
4690.2%
 
7540.2%
 
5350.1%
 
63< 0.1%
 
11< 0.1%
 
ValueCountFrequency (%) 
-2429214.6%
 
-1557818.9%
 
01613854.8%
 
11< 0.1%
 
2311410.6%
 
31750.6%
 
4690.2%
 
5350.1%
 
63< 0.1%
 
7540.2%
 
ValueCountFrequency (%) 
7540.2%
 
63< 0.1%
 
5350.1%
 
4690.2%
 
31750.6%
 
2311410.6%
 
11< 0.1%
 
01613854.8%
 
-1557818.9%
 
-2429214.6%
 

pay_5
Real number (ℝ)

ZEROS

Distinct count9
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-0.2685766658746054
Minimum-2
Maximum7
Zeros16596
Zeros (%)56.3%
Memory size230.3 KiB

Quantile statistics

Minimum-2
5-th percentile-2
Q1-1
median0
Q30
95-th percentile2
Maximum7
Range9
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.131412577
Coefficient of variation (CV)-4.212624256
Kurtosis3.705392297
Mean-0.2685766659
Median Absolute Deviation (MAD)0
Skewness0.9669595996
Sum-7912
Variance1.28009442
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
01659656.3%
 
-1544118.5%
 
-2449615.3%
 
225948.8%
 
31760.6%
 
4840.3%
 
7530.2%
 
5160.1%
 
63< 0.1%
 
ValueCountFrequency (%) 
-2449615.3%
 
-1544118.5%
 
01659656.3%
 
225948.8%
 
31760.6%
 
4840.3%
 
5160.1%
 
63< 0.1%
 
7530.2%
 
ValueCountFrequency (%) 
7530.2%
 
63< 0.1%
 
5160.1%
 
4840.3%
 
31760.6%
 
225948.8%
 
01659656.3%
 
-1544118.5%
 
-2449615.3%
 

pay_6
Real number (ℝ)

ZEROS

Distinct count9
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-0.2940357785396653
Minimum-2
Maximum7
Zeros15949
Zeros (%)54.1%
Memory size230.3 KiB

Quantile statistics

Minimum-2
5-th percentile-2
Q1-1
median0
Q30
95-th percentile2
Maximum7
Range9
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.148624443
Coefficient of variation (CV)-3.906410468
Kurtosis3.194076657
Mean-0.2940357785
Median Absolute Deviation (MAD)0
Skewness0.9137449283
Sum-8662
Variance1.319338111
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
01594954.1%
 
-1563219.1%
 
-2484716.5%
 
227289.3%
 
31830.6%
 
4470.2%
 
7450.2%
 
6160.1%
 
512< 0.1%
 
ValueCountFrequency (%) 
-2484716.5%
 
-1563219.1%
 
01594954.1%
 
227289.3%
 
31830.6%
 
4470.2%
 
512< 0.1%
 
6160.1%
 
7450.2%
 
ValueCountFrequency (%) 
7450.2%
 
6160.1%
 
512< 0.1%
 
4470.2%
 
31830.6%
 
227289.3%
 
01594954.1%
 
-1563219.1%
 
-2484716.5%
 

bill_amt1
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct count22341
Unique (%)75.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean50590.48840761737
Minimum-154973
Maximum613860
Zeros1986
Zeros (%)6.7%
Memory size230.3 KiB

Quantile statistics

Minimum-154973
5-th percentile0
Q13489.5
median22241
Q366841.5
95-th percentile198667.1
Maximum613860
Range768833
Interquartile range (IQR)63352

Descriptive statistics

Standard deviation71711.63921
Coefficient of variation (CV)1.417492526
Kurtosis8.146381789
Mean50590.48841
Median Absolute Deviation (MAD)21674
Skewness2.515873724
Sum1490345198
Variance5142559198
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
019866.7%
 
3902390.8%
 
780720.2%
 
326700.2%
 
316620.2%
 
2500590.2%
 
396490.2%
 
2400360.1%
 
416290.1%
 
500250.1%
 
1050250.1%
 
1473240.1%
 
1261220.1%
 
-200220.1%
 
-5210.1%
 
836200.1%
 
264200.1%
 
-3190.1%
 
291180.1%
 
600170.1%
 
-2170.1%
 
360170.1%
 
-1160.1%
 
-4160.1%
 
1000160.1%
 
Other values (22316)2654290.1%
 
ValueCountFrequency (%) 
-1549731< 0.1%
 
-153081< 0.1%
 
-143861< 0.1%
 
-115451< 0.1%
 
-106821< 0.1%
 
-98021< 0.1%
 
-90951< 0.1%
 
-81871< 0.1%
 
-74381< 0.1%
 
-70821< 0.1%
 
ValueCountFrequency (%) 
6138601< 0.1%
 
6040191< 0.1%
 
5880001< 0.1%
 
5813191< 0.1%
 
5647571< 0.1%
 
5623261< 0.1%
 
5467411< 0.1%
 
5464851< 0.1%
 
5428271< 0.1%
 
5331421< 0.1%
 

bill_amt2
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct count21978
Unique (%)74.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean48617.644862351066
Minimum-69777
Maximum605943
Zeros2472
Zeros (%)8.4%
Memory size230.3 KiB

Quantile statistics

Minimum-69777
5-th percentile0
Q12947.5
median21092
Q363739.5
95-th percentile192512.1
Maximum605943
Range675720
Interquartile range (IQR)60792

Descriptive statistics

Standard deviation69346.89231
Coefficient of variation (CV)1.426372925
Kurtosis8.30586925
Mean48617.64486
Median Absolute Deviation (MAD)20702
Skewness2.536596574
Sum1432227200
Variance4808991473
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
024728.4%
 
3902260.8%
 
326740.3%
 
780720.2%
 
316710.2%
 
2500510.2%
 
396510.2%
 
2400390.1%
 
-200290.1%
 
416280.1%
 
1050250.1%
 
1261240.1%
 
1473230.1%
 
1000220.1%
 
264220.1%
 
291220.1%
 
-3210.1%
 
-2210.1%
 
150200.1%
 
-1180.1%
 
-18180.1%
 
-5180.1%
 
200180.1%
 
300170.1%
 
-4160.1%
 
Other values (21953)2604188.4%
 
ValueCountFrequency (%) 
-697771< 0.1%
 
-675261< 0.1%
 
-333501< 0.1%
 
-300001< 0.1%
 
-262141< 0.1%
 
-247041< 0.1%
 
-247021< 0.1%
 
-186181< 0.1%
 
-178101< 0.1%
 
-159101< 0.1%
 
ValueCountFrequency (%) 
6059431< 0.1%
 
5728341< 0.1%
 
5521441< 0.1%
 
5394181< 0.1%
 
5355091< 0.1%
 
5342891< 0.1%
 
5323741< 0.1%
 
5245551< 0.1%
 
5223091< 0.1%
 
5206431< 0.1%
 

bill_amt3
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct count21668
Unique (%)73.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean46322.599579076006
Minimum-61506
Maximum548020
Zeros2835
Zeros (%)9.6%
Memory size230.3 KiB

Quantile statistics

Minimum-61506
5-th percentile0
Q12626.5
median20035
Q359892
95-th percentile184973.3
Maximum548020
Range609526
Interquartile range (IQR)57265.5

Descriptive statistics

Standard deviation66602.15627
Coefficient of variation (CV)1.437789694
Kurtosis8.474450882
Mean46322.59958
Median Absolute Deviation (MAD)19655
Skewness2.563058617
Sum1364617461
Variance4435847219
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
028359.6%
 
3902680.9%
 
780720.2%
 
316620.2%
 
326610.2%
 
396470.2%
 
2500400.1%
 
2400360.1%
 
416290.1%
 
200270.1%
 
1000250.1%
 
264230.1%
 
-200230.1%
 
-1230.1%
 
500230.1%
 
291230.1%
 
1050220.1%
 
-2220.1%
 
150200.1%
 
-18190.1%
 
-3190.1%
 
1261180.1%
 
380170.1%
 
10000170.1%
 
1170160.1%
 
Other values (21643)2567287.1%
 
ValueCountFrequency (%) 
-615061< 0.1%
 
-461271< 0.1%
 
-340411< 0.1%
 
-254431< 0.1%
 
-247021< 0.1%
 
-203201< 0.1%
 
-159101< 0.1%
 
-156411< 0.1%
 
-150001< 0.1%
 
-149981< 0.1%
 
ValueCountFrequency (%) 
5480201< 0.1%
 
5375431< 0.1%
 
5341371< 0.1%
 
5234231< 0.1%
 
5204921< 0.1%
 
5192671< 0.1%
 
5177461< 0.1%
 
4999361< 0.1%
 
4988391< 0.1%
 
4986461< 0.1%
 

bill_amt4
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct count21181
Unique (%)71.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean42509.289079737944
Minimum-65167
Maximum542653
Zeros3160
Zeros (%)10.7%
Memory size230.3 KiB

Quantile statistics

Minimum-65167
5-th percentile0
Q12296
median19000
Q354060.5
95-th percentile170693.5
Maximum542653
Range607820
Interquartile range (IQR)51764.5

Descriptive statistics

Standard deviation62052.36241
Coefficient of variation (CV)1.459736536
Kurtosis9.267970891
Mean42509.28908
Median Absolute Deviation (MAD)18604
Skewness2.647260391
Sum1252281147
Variance3850495680
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0316010.7%
 
3902420.8%
 
780970.3%
 
316680.2%
 
326610.2%
 
396440.1%
 
150380.1%
 
2400360.1%
 
2500340.1%
 
416330.1%
 
1000320.1%
 
-3270.1%
 
-1240.1%
 
-18240.1%
 
1050240.1%
 
1261240.1%
 
-2230.1%
 
300220.1%
 
291210.1%
 
600200.1%
 
264170.1%
 
380160.1%
 
632160.1%
 
1170160.1%
 
-10160.1%
 
Other values (21156)2532486.0%
 
ValueCountFrequency (%) 
-651671< 0.1%
 
-506161< 0.1%
 
-466271< 0.1%
 
-345031< 0.1%
 
-274901< 0.1%
 
-243031< 0.1%
 
-221081< 0.1%
 
-203201< 0.1%
 
-172501< 0.1%
 
-159101< 0.1%
 
ValueCountFrequency (%) 
5426531< 0.1%
 
5410191< 0.1%
 
5306721< 0.1%
 
5257491< 0.1%
 
5187411< 0.1%
 
5055071< 0.1%
 
5049291< 0.1%
 
4964001< 0.1%
 
4935481< 0.1%
 
4899781< 0.1%
 

bill_amt5
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct count20657
Unique (%)70.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean39567.07165891578
Minimum-61372
Maximum516139
Zeros3470
Zeros (%)11.8%
Memory size230.3 KiB

Quantile statistics

Minimum-61372
5-th percentile0
Q11740
median18037
Q349985
95-th percentile162132.4
Maximum516139
Range577511
Interquartile range (IQR)48245

Descriptive statistics

Standard deviation58554.19347
Coefficient of variation (CV)1.479871798
Kurtosis9.458562009
Mean39567.07166
Median Absolute Deviation (MAD)17623
Skewness2.664496252
Sum1165606364
Variance3428593573
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0347011.8%
 
3902300.8%
 
780920.3%
 
316790.3%
 
326590.2%
 
150580.2%
 
396470.2%
 
2400360.1%
 
416360.1%
 
2500350.1%
 
-18320.1%
 
1000300.1%
 
300250.1%
 
-1230.1%
 
1050230.1%
 
10000220.1%
 
1473220.1%
 
600210.1%
 
1261190.1%
 
291190.1%
 
540180.1%
 
-3180.1%
 
500180.1%
 
20000170.1%
 
-200170.1%
 
Other values (20632)2499384.8%
 
ValueCountFrequency (%) 
-613721< 0.1%
 
-530071< 0.1%
 
-466271< 0.1%
 
-375941< 0.1%
 
-304811< 0.1%
 
-283351< 0.1%
 
-230031< 0.1%
 
-207531< 0.1%
 
-203201< 0.1%
 
-202541< 0.1%
 
ValueCountFrequency (%) 
5161391< 0.1%
 
5054731< 0.1%
 
5039141< 0.1%
 
5014741< 0.1%
 
5007231< 0.1%
 
4930621< 0.1%
 
4892001< 0.1%
 
4867211< 0.1%
 
4849931< 0.1%
 
4846121< 0.1%
 

bill_amt6
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct count20252
Unique (%)68.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean38171.25269017957
Minimum-150953
Maximum527711
Zeros3969
Zeros (%)13.5%
Memory size230.3 KiB

Quantile statistics

Minimum-150953
5-th percentile0
Q11239.5
median16944
Q348951
95-th percentile157644.6
Maximum527711
Range678664
Interquartile range (IQR)47711.5

Descriptive statistics

Standard deviation57439.09415
Coefficient of variation (CV)1.504773622
Kurtosis9.666381652
Mean38171.25269
Median Absolute Deviation (MAD)16628
Skewness2.679392755
Sum1124486933
Variance3299249537
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0396913.5%
 
3902010.7%
 
780840.3%
 
316770.3%
 
150750.3%
 
326540.2%
 
396450.2%
 
416360.1%
 
-18330.1%
 
2400300.1%
 
2500300.1%
 
500290.1%
 
540290.1%
 
1000290.1%
 
300260.1%
 
10000260.1%
 
930240.1%
 
1050230.1%
 
-2230.1%
 
-1220.1%
 
291200.1%
 
-200200.1%
 
1650180.1%
 
1320170.1%
 
600170.1%
 
Other values (20227)2450283.2%
 
ValueCountFrequency (%) 
-1509531< 0.1%
 
-946251< 0.1%
 
-738951< 0.1%
 
-570601< 0.1%
 
-514431< 0.1%
 
-511831< 0.1%
 
-466271< 0.1%
 
-457341< 0.1%
 
-390461< 0.1%
 
-308951< 0.1%
 
ValueCountFrequency (%) 
5277111< 0.1%
 
5275661< 0.1%
 
5149751< 0.1%
 
5119051< 0.1%
 
4983161< 0.1%
 
4969151< 0.1%
 
4892001< 0.1%
 
4805981< 0.1%
 
4780341< 0.1%
 
4744591< 0.1%
 

pay_amt1
Real number (ℝ≥0)

ZEROS

Distinct count7801
Unique (%)26.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5466.546793849078
Minimum0
Maximum302000
Zeros5169
Zeros (%)17.5%
Memory size230.3 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1999.5
median2100
Q35002
95-th percentile18000
Maximum302000
Range302000
Interquartile range (IQR)4002.5

Descriptive statistics

Standard deviation14218.1229
Coefficient of variation (CV)2.600933174
Kurtosis122.0760149
Mean5466.546794
Median Absolute Deviation (MAD)1929
Skewness9.380222078
Sum161039002
Variance202155018.8
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0516917.5%
 
200013414.6%
 
30008803.0%
 
50006932.4%
 
15004961.7%
 
40004211.4%
 
100003921.3%
 
10003521.2%
 
25002951.0%
 
60002901.0%
 
3902020.7%
 
70001950.7%
 
35001840.6%
 
13001810.6%
 
80001710.6%
 
16001700.6%
 
18001610.5%
 
17001550.5%
 
12001310.4%
 
21001280.4%
 
45001060.4%
 
22001060.4%
 
15000940.3%
 
1400930.3%
 
3200840.3%
 
Other values (7776)1696957.6%
 
ValueCountFrequency (%) 
0516917.5%
 
19< 0.1%
 
214< 0.1%
 
3150.1%
 
4170.1%
 
511< 0.1%
 
6150.1%
 
79< 0.1%
 
88< 0.1%
 
97< 0.1%
 
ValueCountFrequency (%) 
3020001< 0.1%
 
3000391< 0.1%
 
2988871< 0.1%
 
2766981< 0.1%
 
2738441< 0.1%
 
2728171< 0.1%
 
2615241< 0.1%
 
2604161< 0.1%
 
2600001< 0.1%
 
2475621< 0.1%
 

pay_amt2
Real number (ℝ≥0)

ZEROS

Distinct count7780
Unique (%)26.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5526.86520248481
Minimum0
Maximum312723
Zeros5309
Zeros (%)18.0%
Memory size230.3 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1827
median2008
Q35000
95-th percentile18516.2
Maximum312723
Range312723
Interquartile range (IQR)4173

Descriptive statistics

Standard deviation15196.49566
Coefficient of variation (CV)2.749568716
Kurtosis116.8410004
Mean5526.865202
Median Absolute Deviation (MAD)1992
Skewness9.283326882
Sum162815922
Variance230933480.3
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0530918.0%
 
200012724.3%
 
30008472.9%
 
50007102.4%
 
10005812.0%
 
15005061.7%
 
40004051.4%
 
100003141.1%
 
60002801.0%
 
25002450.8%
 
3902290.8%
 
12002000.7%
 
16001810.6%
 
13001690.6%
 
70001680.6%
 
35001660.6%
 
80001430.5%
 
14001400.5%
 
18001350.5%
 
17001340.5%
 
22001160.4%
 
21001080.4%
 
4500980.3%
 
20000790.3%
 
9000760.3%
 
Other values (7755)1684857.2%
 
ValueCountFrequency (%) 
0530918.0%
 
1150.1%
 
2200.1%
 
3180.1%
 
411< 0.1%
 
5240.1%
 
68< 0.1%
 
712< 0.1%
 
89< 0.1%
 
96< 0.1%
 
ValueCountFrequency (%) 
3127231< 0.1%
 
3029611< 0.1%
 
3020001< 0.1%
 
3000181< 0.1%
 
3000001< 0.1%
 
2943181< 0.1%
 
2790481< 0.1%
 
2785051< 0.1%
 
2775101< 0.1%
 
2745261< 0.1%
 

pay_amt3
Real number (ℝ≥0)

ZEROS

Distinct count7368
Unique (%)25.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4727.996062323908
Minimum0
Maximum174749
Zeros5884
Zeros (%)20.0%
Memory size230.3 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1390
median1800
Q34500
95-th percentile16683.5
Maximum174749
Range174749
Interquartile range (IQR)4110

Descriptive statistics

Standard deviation11847.61376
Coefficient of variation (CV)2.505842561
Kurtosis67.09497284
Mean4727.996062
Median Absolute Deviation (MAD)1794
Skewness7.242447034
Sum139282036
Variance140365951.8
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0588420.0%
 
200012684.3%
 
100010793.7%
 
30008632.9%
 
50007142.4%
 
15004791.6%
 
40003781.3%
 
100003081.0%
 
12002380.8%
 
60002360.8%
 
25002250.8%
 
3902050.7%
 
13001580.5%
 
5001520.5%
 
70001520.5%
 
80001420.5%
 
35001400.5%
 
16001310.4%
 
14001200.4%
 
18001190.4%
 
17001020.3%
 
20000830.3%
 
1100830.3%
 
4500830.3%
 
15000790.3%
 
Other values (7343)1603854.4%
 
ValueCountFrequency (%) 
0588420.0%
 
112< 0.1%
 
2190.1%
 
314< 0.1%
 
4150.1%
 
5180.1%
 
614< 0.1%
 
7180.1%
 
89< 0.1%
 
911< 0.1%
 
ValueCountFrequency (%) 
1747491< 0.1%
 
1741691< 0.1%
 
1692671< 0.1%
 
1668531< 0.1%
 
1638621< 0.1%
 
1635971< 0.1%
 
1625461< 0.1%
 
1624341< 0.1%
 
1609441< 0.1%
 
1605781< 0.1%
 

pay_amt4
Real number (ℝ≥0)

ZEROS

Distinct count6812
Unique (%)23.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4525.890457924573
Minimum0
Maximum211250
Zeros6324
Zeros (%)21.5%
Memory size230.3 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1291
median1500
Q34000
95-th percentile15653.2
Maximum211250
Range211250
Interquartile range (IQR)3709

Descriptive statistics

Standard deviation12386.75176
Coefficient of variation (CV)2.736865126
Kurtosis82.87101708
Mean4525.890458
Median Absolute Deviation (MAD)1500
Skewness7.938938306
Sum133328207
Variance153431619.1
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0632421.5%
 
100013604.6%
 
200011994.1%
 
30008813.0%
 
50008002.7%
 
15004361.5%
 
40004001.4%
 
100003341.1%
 
25002540.9%
 
60002500.8%
 
5002480.8%
 
3902050.7%
 
12001690.6%
 
35001670.6%
 
70001600.5%
 
11001390.5%
 
7001370.5%
 
6001200.4%
 
80001170.4%
 
800900.3%
 
1300850.3%
 
20000850.3%
 
1600840.3%
 
1800800.3%
 
4500770.3%
 
Other values (6787)1525851.8%
 
ValueCountFrequency (%) 
0632421.5%
 
1210.1%
 
2220.1%
 
313< 0.1%
 
4200.1%
 
512< 0.1%
 
6160.1%
 
711< 0.1%
 
87< 0.1%
 
99< 0.1%
 
ValueCountFrequency (%) 
2112501< 0.1%
 
2088211< 0.1%
 
2050001< 0.1%
 
2020761< 0.1%
 
2001281< 0.1%
 
2000001< 0.1%
 
1949891< 0.1%
 
1937121< 0.1%
 
1929941< 0.1%
 
1900711< 0.1%
 

pay_amt5
Real number (ℝ≥0)

ZEROS

Distinct count6778
Unique (%)23.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4520.030143589395
Minimum0
Maximum208122
Zeros6603
Zeros (%)22.4%
Memory size230.3 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1246.5
median1500
Q34003
95-th percentile15396.2
Maximum208122
Range208122
Interquartile range (IQR)3756.5

Descriptive statistics

Standard deviation12525.53963
Coefficient of variation (CV)2.771118607
Kurtosis87.87586793
Mean4520.030144
Median Absolute Deviation (MAD)1500
Skewness8.191554741
Sum133155568
Variance156889143.1
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0660322.4%
 
100013064.4%
 
200013054.4%
 
30009373.2%
 
50008082.7%
 
15004161.4%
 
40003991.4%
 
100003371.1%
 
5002460.8%
 
60002430.8%
 
25002290.8%
 
3901730.6%
 
12001590.5%
 
70001570.5%
 
35001570.5%
 
11001250.4%
 
80001160.4%
 
7001150.4%
 
6001130.4%
 
16001000.3%
 
20000900.3%
 
1300890.3%
 
4500870.3%
 
1800870.3%
 
800810.3%
 
Other values (6753)1498150.9%
 
ValueCountFrequency (%) 
0660322.4%
 
1210.1%
 
213< 0.1%
 
313< 0.1%
 
411< 0.1%
 
58< 0.1%
 
67< 0.1%
 
79< 0.1%
 
86< 0.1%
 
96< 0.1%
 
ValueCountFrequency (%) 
2081221< 0.1%
 
2074401< 0.1%
 
2070191< 0.1%
 
2054301< 0.1%
 
2050001< 0.1%
 
2023171< 0.1%
 
2000001< 0.1%
 
1958291< 0.1%
 
1955991< 0.1%
 
1945411< 0.1%
 

pay_amt6
Real number (ℝ≥0)

ZEROS

Distinct count6813
Unique (%)23.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4851.510540072643
Minimum0
Maximum211192
Zeros7065
Zeros (%)24.0%
Memory size230.3 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1107
median1500
Q34000
95-th percentile16951.1
Maximum211192
Range211192
Interquartile range (IQR)3893

Descriptive statistics

Standard deviation14468.86445
Coefficient of variation (CV)2.982342165
Kurtosis77.5713468
Mean4851.51054
Median Absolute Deviation (MAD)1500
Skewness7.90083514
Sum142920649
Variance209348038.5
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0706524.0%
 
200012744.3%
 
100012684.3%
 
30009073.1%
 
50008002.7%
 
15004351.5%
 
40004051.4%
 
100003501.2%
 
5002420.8%
 
60002180.7%
 
25002110.7%
 
3901700.6%
 
35001590.5%
 
70001460.5%
 
12001440.5%
 
80001140.4%
 
6001100.4%
 
11001070.4%
 
4500990.3%
 
1600970.3%
 
700970.3%
 
800950.3%
 
780910.3%
 
1300800.3%
 
1700800.3%
 
Other values (6788)1469549.9%
 
ValueCountFrequency (%) 
0706524.0%
 
1200.1%
 
29< 0.1%
 
314< 0.1%
 
412< 0.1%
 
57< 0.1%
 
66< 0.1%
 
75< 0.1%
 
86< 0.1%
 
97< 0.1%
 
ValueCountFrequency (%) 
2111921< 0.1%
 
2107591< 0.1%
 
2100001< 0.1%
 
2088961< 0.1%
 
2043951< 0.1%
 
2042971< 0.1%
 
2013231< 0.1%
 
2012771< 0.1%
 
2011341< 0.1%
 
2006551< 0.1%
 

defaulted
Boolean

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size230.3 KiB
0
22940
1
6519
ValueCountFrequency (%) 
02294077.9%
 
1651922.1%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Missing values

Sample

First rows

df_indexlimit_balsexeducationmarriageagepay_0pay_2pay_3pay_4pay_5pay_6bill_amt1bill_amt2bill_amt3bill_amt4bill_amt5bill_amt6pay_amt1pay_amt2pay_amt3pay_amt4pay_amt5pay_amt6defaulted
00200002212422-1-1-2-239133102689000068900001
1112000022226-1200022682172526823272345532610100010001000020001
2290000222340000002923914027135591433114948155491518150010001000100050000
3350000221370000004699048233492912831428959295472000201912001100106910000
445000012157-10-100086175670358352094019146191312000366811000090006896790
55500001123700000064400570695760819394196192002425001815657100010008000
66500000112290000003679654120234450075426534830034739445500040000380002023913750137700
77100000222230-1-100-111876380601221-1595673806010581168715420
881400002312800200011285140961210812211117933719332904321000100010000
992000013235-2-2-2-2-1-10000130071391200013007112200

Last rows

df_indexlimit_balsexeducationmarriageagepay_0pay_2pay_3pay_4pay_5pay_6bill_amt1bill_amt2bill_amt3bill_amt4bill_amt5bill_amt6pay_amt1pay_amt2pay_amt3pay_amt4pay_amt5pay_amt6defaulted
29449299901400001214100000013832513714213911013826249675461216000700042281505200020000
2945029991210000121343222222500250025002500250025000000001
29451299921000013143000-2-2-288021040000002000000000
2945229993100000112380-1-100030421427102996706266947355004200011178440003000200020000
294532999480000122342222227255777708793847751982607811587000350007000040001
29454299952200001313900000018894819281520836588004312371598085002000050033047500010000
294552999615000013243-1-1-1-100168318283502897951900183735268998129000
29456299973000012237432-10035653356275820878205821935700220004200200031001
294572999880000131411-1000-1-16457837976304527741185548944859003409117819265296418041
294582999950000121460000004792948905497643653532428153132078180014301000100010001